package com.neusoft.tijiancms.mapper;

import com.neusoft.tijiancms.po.Overallresult;
import org.apache.ibatis.annotations.*;

import java.util.List;
@Mapper
public interface OverallresultMapper {
    /**
     * 查询总检结论
     * @param orderId
     * @return
     */
    @Select("SELECT * FROM overallresult where orderId=#{orderId}")
    public List<Overallresult> listOverallResultByOrderId(Integer orderId);

    /**
     * 添加总检结论信息
     * @param overallresult
     * @return
     */
    @Insert("insert into overallresult (title,content,orderId) values (#{title},#{content},#{orderId})")
    public int saveOverallResult(Overallresult overallresult);

    /**
     * 更新总检结论信息
     * @param overallresult
     * @return
     */
    @Update("update overallresult set title=#{title},content=#{content} where orderId=#{orderId}")
    public int updateOverallResult(Overallresult overallresult);

    /**
     * 删除总检结论信息
     * @param overallresult
     * @return
     */
    @Delete("delete from overallresult where orderId=#{orderId} ")
    public  int removeOverallResult(Overallresult overallresult);
}
